package com.winshare.saleAssistant.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.winshare.saleAssistant.model.School;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * <p>
 * 学校基础信息 Mapper 接口
 * </p>
 *
 * @author stylefeng
 * @since 2020-11-06
 */
public interface SchoolMapper extends BaseMapper<School> {

    List<Map<String,Object>> getList(@Param("page") Page<Map<String,Object>> page);

    List<School> selectNumber(@Param("page")Page<School>page,@Param("checkbox")Boolean checkbox, @Param("province")String province, @Param("city")String city,  @Param("areaName")String areaName,  @Param("condition")String condition);

    Integer getSchoolCount(@Param("starTime") Date starTime, @Param("endTime") Date endTime);

    Integer getSchoolCount1(@Param("starTime") Date starTime, @Param("endTime") Date endTime,@Param("productName") String productName);

    Integer getCTotal(@Param("starTime")Date starTime, @Param("endTime")Date endTime,@Param("productName")String productName);

    Integer getATotal(@Param("starTime")Date starTime,@Param("endTime") Date endTime,@Param("productName")String productName);

    String getLastTime();



}
